Backing Up Databases

To protect the information in your database, Ektron recommends backing it up before upgrading. During the upgrade, Ektron attempts to create a backup of your database. If that fails, use the following MSDN links for instructions on backing up and restoring your database via SQL Server.

To work with this database version	See this MSDN article
Backup SQL Server 2008	http://msdn.microsoft.com/en-us/library/ms187510.aspx NOTE: The bottom of the above page provides links to options for restoring the backed-up database.
Backup SQL Server 2005	http://msdn.microsoft.com/en-us/library/ms187510(SQL.90).aspx NOTE: The bottom of the above page provides links to options for restoring the backed-up database.

To work with this database version

See this MSDN article

Backup SQL Server 2008

http://msdn.microsoft.com/en-us/library/ms187510.aspx

NOTE: The bottom of the above page provides links to options for restoring the backed-up database.

Backup SQL Server 2005

http://msdn.microsoft.com/en-us/library/ms187510(SQL.90).aspx

NOTE: The bottom of the above page provides links to options for restoring the backed-up database.

IMPORTANT: Before restoring an SQL database, either stop the Ektron Windows service or force all connections closed. You need to do this because the Ektron Windows Service accesses the database. To view and update the status of the service, go to Computer Management > Services and Applications > Services. For more information, see Ektron Windows Service.